﻿

if not Exists(select * from sysobjects where name = 'NewsLetterNewsLetter' and Xtype = 'U') 
Begin

	Create table dbo.NewsLetterNewsLetter (
		Id int identity(1,1) not null,
		HtmlContent varchar(max) not null,
		Version timestamp not null,
		CreationDate datetime not null,
		LastUpdate datetime not null,
		OwnerId int null,
	)

	alter table dbo.NewsLetterNewsLetter add constraint PK_NewsLetterNewsLetter_Id primary key (Id)

	DBCC CHECKIDENT (NewsLetterNewsLetter, RESEED, 1000)
End